﻿ALTER TABLE [dbo].[Room]
	ADD CONSTRAINT [RoomToRoomType] 
	FOREIGN KEY ([RoomTypeId])
	REFERENCES [dbo].[RoomType] ([Id])
	ON UPDATE CASCADE
	ON DELETE SET NULL
